USE [MMS]
GO

/****** Object:  Trigger [dbo].[TR_AS_UPDATE_ASSET_STATUS]    Script Date: 12/03/2012 23:08:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[TR_AS_UPDATE_ASSET_STATUS] ON [dbo].[MMS_ASSET_STATUS] 
  AFTER UPDATE AS
BEGIN

  SET NOCOUNT ON;
  UPDATE [dbo].[MMS_ASSET_STATUS] 
  SET StatusDate = getdate() 
  WHERE id = (select id from inserted)

END

GO